package com.base.po.voip;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RebateOrdersJdExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RebateOrdersJdExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderidIsNull() {
            addCriterion("OrderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("OrderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(String value) {
            addCriterion("OrderId =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(String value) {
            addCriterion("OrderId <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(String value) {
            addCriterion("OrderId >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(String value) {
            addCriterion("OrderId >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(String value) {
            addCriterion("OrderId <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(String value) {
            addCriterion("OrderId <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLike(String value) {
            addCriterion("OrderId like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotLike(String value) {
            addCriterion("OrderId not like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<String> values) {
            addCriterion("OrderId in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<String> values) {
            addCriterion("OrderId not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(String value1, String value2) {
            addCriterion("OrderId between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(String value1, String value2) {
            addCriterion("OrderId not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andSkuidIsNull() {
            addCriterion("SkuId is null");
            return (Criteria) this;
        }

        public Criteria andSkuidIsNotNull() {
            addCriterion("SkuId is not null");
            return (Criteria) this;
        }

        public Criteria andSkuidEqualTo(String value) {
            addCriterion("SkuId =", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotEqualTo(String value) {
            addCriterion("SkuId <>", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidGreaterThan(String value) {
            addCriterion("SkuId >", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidGreaterThanOrEqualTo(String value) {
            addCriterion("SkuId >=", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidLessThan(String value) {
            addCriterion("SkuId <", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidLessThanOrEqualTo(String value) {
            addCriterion("SkuId <=", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidLike(String value) {
            addCriterion("SkuId like", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotLike(String value) {
            addCriterion("SkuId not like", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidIn(List<String> values) {
            addCriterion("SkuId in", values, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotIn(List<String> values) {
            addCriterion("SkuId not in", values, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidBetween(String value1, String value2) {
            addCriterion("SkuId between", value1, value2, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotBetween(String value1, String value2) {
            addCriterion("SkuId not between", value1, value2, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkunameIsNull() {
            addCriterion("SkuName is null");
            return (Criteria) this;
        }

        public Criteria andSkunameIsNotNull() {
            addCriterion("SkuName is not null");
            return (Criteria) this;
        }

        public Criteria andSkunameEqualTo(String value) {
            addCriterion("SkuName =", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotEqualTo(String value) {
            addCriterion("SkuName <>", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameGreaterThan(String value) {
            addCriterion("SkuName >", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameGreaterThanOrEqualTo(String value) {
            addCriterion("SkuName >=", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLessThan(String value) {
            addCriterion("SkuName <", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLessThanOrEqualTo(String value) {
            addCriterion("SkuName <=", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLike(String value) {
            addCriterion("SkuName like", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotLike(String value) {
            addCriterion("SkuName not like", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameIn(List<String> values) {
            addCriterion("SkuName in", values, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotIn(List<String> values) {
            addCriterion("SkuName not in", values, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameBetween(String value1, String value2) {
            addCriterion("SkuName between", value1, value2, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotBetween(String value1, String value2) {
            addCriterion("SkuName not between", value1, value2, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunumIsNull() {
            addCriterion("SkuNum is null");
            return (Criteria) this;
        }

        public Criteria andSkunumIsNotNull() {
            addCriterion("SkuNum is not null");
            return (Criteria) this;
        }

        public Criteria andSkunumEqualTo(Integer value) {
            addCriterion("SkuNum =", value, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumNotEqualTo(Integer value) {
            addCriterion("SkuNum <>", value, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumGreaterThan(Integer value) {
            addCriterion("SkuNum >", value, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumGreaterThanOrEqualTo(Integer value) {
            addCriterion("SkuNum >=", value, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumLessThan(Integer value) {
            addCriterion("SkuNum <", value, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumLessThanOrEqualTo(Integer value) {
            addCriterion("SkuNum <=", value, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumIn(List<Integer> values) {
            addCriterion("SkuNum in", values, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumNotIn(List<Integer> values) {
            addCriterion("SkuNum not in", values, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumBetween(Integer value1, Integer value2) {
            addCriterion("SkuNum between", value1, value2, "skunum");
            return (Criteria) this;
        }

        public Criteria andSkunumNotBetween(Integer value1, Integer value2) {
            addCriterion("SkuNum not between", value1, value2, "skunum");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("Price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("Price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("Price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("Price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("Price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("Price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("Price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("Price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPaypriceIsNull() {
            addCriterion("PayPrice is null");
            return (Criteria) this;
        }

        public Criteria andPaypriceIsNotNull() {
            addCriterion("PayPrice is not null");
            return (Criteria) this;
        }

        public Criteria andPaypriceEqualTo(BigDecimal value) {
            addCriterion("PayPrice =", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceNotEqualTo(BigDecimal value) {
            addCriterion("PayPrice <>", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceGreaterThan(BigDecimal value) {
            addCriterion("PayPrice >", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PayPrice >=", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceLessThan(BigDecimal value) {
            addCriterion("PayPrice <", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PayPrice <=", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceIn(List<BigDecimal> values) {
            addCriterion("PayPrice in", values, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceNotIn(List<BigDecimal> values) {
            addCriterion("PayPrice not in", values, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PayPrice between", value1, value2, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PayPrice not between", value1, value2, "payprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceIsNull() {
            addCriterion("EstimateCosPrice is null");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceIsNotNull() {
            addCriterion("EstimateCosPrice is not null");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceEqualTo(BigDecimal value) {
            addCriterion("EstimateCosPrice =", value, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceNotEqualTo(BigDecimal value) {
            addCriterion("EstimateCosPrice <>", value, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceGreaterThan(BigDecimal value) {
            addCriterion("EstimateCosPrice >", value, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("EstimateCosPrice >=", value, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceLessThan(BigDecimal value) {
            addCriterion("EstimateCosPrice <", value, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("EstimateCosPrice <=", value, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceIn(List<BigDecimal> values) {
            addCriterion("EstimateCosPrice in", values, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceNotIn(List<BigDecimal> values) {
            addCriterion("EstimateCosPrice not in", values, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("EstimateCosPrice between", value1, value2, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecospriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("EstimateCosPrice not between", value1, value2, "estimatecosprice");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionIsNull() {
            addCriterion("EstimateCommission is null");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionIsNotNull() {
            addCriterion("EstimateCommission is not null");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionEqualTo(BigDecimal value) {
            addCriterion("EstimateCommission =", value, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionNotEqualTo(BigDecimal value) {
            addCriterion("EstimateCommission <>", value, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionGreaterThan(BigDecimal value) {
            addCriterion("EstimateCommission >", value, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("EstimateCommission >=", value, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionLessThan(BigDecimal value) {
            addCriterion("EstimateCommission <", value, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("EstimateCommission <=", value, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionIn(List<BigDecimal> values) {
            addCriterion("EstimateCommission in", values, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionNotIn(List<BigDecimal> values) {
            addCriterion("EstimateCommission not in", values, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("EstimateCommission between", value1, value2, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andEstimatecommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("EstimateCommission not between", value1, value2, "estimatecommission");
            return (Criteria) this;
        }

        public Criteria andCommissionrateIsNull() {
            addCriterion("CommissionRate is null");
            return (Criteria) this;
        }

        public Criteria andCommissionrateIsNotNull() {
            addCriterion("CommissionRate is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionrateEqualTo(BigDecimal value) {
            addCriterion("CommissionRate =", value, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateNotEqualTo(BigDecimal value) {
            addCriterion("CommissionRate <>", value, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateGreaterThan(BigDecimal value) {
            addCriterion("CommissionRate >", value, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CommissionRate >=", value, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateLessThan(BigDecimal value) {
            addCriterion("CommissionRate <", value, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CommissionRate <=", value, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateIn(List<BigDecimal> values) {
            addCriterion("CommissionRate in", values, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateNotIn(List<BigDecimal> values) {
            addCriterion("CommissionRate not in", values, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CommissionRate between", value1, value2, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andCommissionrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CommissionRate not between", value1, value2, "commissionrate");
            return (Criteria) this;
        }

        public Criteria andActualcospriceIsNull() {
            addCriterion("ActualCosPrice is null");
            return (Criteria) this;
        }

        public Criteria andActualcospriceIsNotNull() {
            addCriterion("ActualCosPrice is not null");
            return (Criteria) this;
        }

        public Criteria andActualcospriceEqualTo(BigDecimal value) {
            addCriterion("ActualCosPrice =", value, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceNotEqualTo(BigDecimal value) {
            addCriterion("ActualCosPrice <>", value, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceGreaterThan(BigDecimal value) {
            addCriterion("ActualCosPrice >", value, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ActualCosPrice >=", value, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceLessThan(BigDecimal value) {
            addCriterion("ActualCosPrice <", value, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ActualCosPrice <=", value, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceIn(List<BigDecimal> values) {
            addCriterion("ActualCosPrice in", values, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceNotIn(List<BigDecimal> values) {
            addCriterion("ActualCosPrice not in", values, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ActualCosPrice between", value1, value2, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcospriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ActualCosPrice not between", value1, value2, "actualcosprice");
            return (Criteria) this;
        }

        public Criteria andActualcommissionIsNull() {
            addCriterion("ActualCommission is null");
            return (Criteria) this;
        }

        public Criteria andActualcommissionIsNotNull() {
            addCriterion("ActualCommission is not null");
            return (Criteria) this;
        }

        public Criteria andActualcommissionEqualTo(BigDecimal value) {
            addCriterion("ActualCommission =", value, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionNotEqualTo(BigDecimal value) {
            addCriterion("ActualCommission <>", value, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionGreaterThan(BigDecimal value) {
            addCriterion("ActualCommission >", value, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ActualCommission >=", value, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionLessThan(BigDecimal value) {
            addCriterion("ActualCommission <", value, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ActualCommission <=", value, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionIn(List<BigDecimal> values) {
            addCriterion("ActualCommission in", values, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionNotIn(List<BigDecimal> values) {
            addCriterion("ActualCommission not in", values, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ActualCommission between", value1, value2, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andActualcommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ActualCommission not between", value1, value2, "actualcommission");
            return (Criteria) this;
        }

        public Criteria andFinalrateIsNull() {
            addCriterion("FinalRate is null");
            return (Criteria) this;
        }

        public Criteria andFinalrateIsNotNull() {
            addCriterion("FinalRate is not null");
            return (Criteria) this;
        }

        public Criteria andFinalrateEqualTo(BigDecimal value) {
            addCriterion("FinalRate =", value, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateNotEqualTo(BigDecimal value) {
            addCriterion("FinalRate <>", value, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateGreaterThan(BigDecimal value) {
            addCriterion("FinalRate >", value, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FinalRate >=", value, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateLessThan(BigDecimal value) {
            addCriterion("FinalRate <", value, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FinalRate <=", value, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateIn(List<BigDecimal> values) {
            addCriterion("FinalRate in", values, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateNotIn(List<BigDecimal> values) {
            addCriterion("FinalRate not in", values, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FinalRate between", value1, value2, "finalrate");
            return (Criteria) this;
        }

        public Criteria andFinalrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FinalRate not between", value1, value2, "finalrate");
            return (Criteria) this;
        }

        public Criteria andValidcodeIsNull() {
            addCriterion("ValidCode is null");
            return (Criteria) this;
        }

        public Criteria andValidcodeIsNotNull() {
            addCriterion("ValidCode is not null");
            return (Criteria) this;
        }

        public Criteria andValidcodeEqualTo(Integer value) {
            addCriterion("ValidCode =", value, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeNotEqualTo(Integer value) {
            addCriterion("ValidCode <>", value, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeGreaterThan(Integer value) {
            addCriterion("ValidCode >", value, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ValidCode >=", value, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeLessThan(Integer value) {
            addCriterion("ValidCode <", value, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeLessThanOrEqualTo(Integer value) {
            addCriterion("ValidCode <=", value, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeIn(List<Integer> values) {
            addCriterion("ValidCode in", values, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeNotIn(List<Integer> values) {
            addCriterion("ValidCode not in", values, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeBetween(Integer value1, Integer value2) {
            addCriterion("ValidCode between", value1, value2, "validcode");
            return (Criteria) this;
        }

        public Criteria andValidcodeNotBetween(Integer value1, Integer value2) {
            addCriterion("ValidCode not between", value1, value2, "validcode");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNull() {
            addCriterion("OrderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("OrderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(Date value) {
            addCriterion("OrderTime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(Date value) {
            addCriterion("OrderTime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(Date value) {
            addCriterion("OrderTime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(Date value) {
            addCriterion("OrderTime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(Date value) {
            addCriterion("OrderTime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(Date value) {
            addCriterion("OrderTime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<Date> values) {
            addCriterion("OrderTime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<Date> values) {
            addCriterion("OrderTime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(Date value1, Date value2) {
            addCriterion("OrderTime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(Date value1, Date value2) {
            addCriterion("OrderTime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeIsNull() {
            addCriterion("FinishTime is null");
            return (Criteria) this;
        }

        public Criteria andFinishtimeIsNotNull() {
            addCriterion("FinishTime is not null");
            return (Criteria) this;
        }

        public Criteria andFinishtimeEqualTo(Date value) {
            addCriterion("FinishTime =", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeNotEqualTo(Date value) {
            addCriterion("FinishTime <>", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeGreaterThan(Date value) {
            addCriterion("FinishTime >", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("FinishTime >=", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeLessThan(Date value) {
            addCriterion("FinishTime <", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeLessThanOrEqualTo(Date value) {
            addCriterion("FinishTime <=", value, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeIn(List<Date> values) {
            addCriterion("FinishTime in", values, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeNotIn(List<Date> values) {
            addCriterion("FinishTime not in", values, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeBetween(Date value1, Date value2) {
            addCriterion("FinishTime between", value1, value2, "finishtime");
            return (Criteria) this;
        }

        public Criteria andFinishtimeNotBetween(Date value1, Date value2) {
            addCriterion("FinishTime not between", value1, value2, "finishtime");
            return (Criteria) this;
        }

        public Criteria andPaymonthIsNull() {
            addCriterion("PayMonth is null");
            return (Criteria) this;
        }

        public Criteria andPaymonthIsNotNull() {
            addCriterion("PayMonth is not null");
            return (Criteria) this;
        }

        public Criteria andPaymonthEqualTo(Date value) {
            addCriterion("PayMonth =", value, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthNotEqualTo(Date value) {
            addCriterion("PayMonth <>", value, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthGreaterThan(Date value) {
            addCriterion("PayMonth >", value, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthGreaterThanOrEqualTo(Date value) {
            addCriterion("PayMonth >=", value, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthLessThan(Date value) {
            addCriterion("PayMonth <", value, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthLessThanOrEqualTo(Date value) {
            addCriterion("PayMonth <=", value, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthIn(List<Date> values) {
            addCriterion("PayMonth in", values, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthNotIn(List<Date> values) {
            addCriterion("PayMonth not in", values, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthBetween(Date value1, Date value2) {
            addCriterion("PayMonth between", value1, value2, "paymonth");
            return (Criteria) this;
        }

        public Criteria andPaymonthNotBetween(Date value1, Date value2) {
            addCriterion("PayMonth not between", value1, value2, "paymonth");
            return (Criteria) this;
        }

        public Criteria andUserCommissionIsNull() {
            addCriterion("User_commission is null");
            return (Criteria) this;
        }

        public Criteria andUserCommissionIsNotNull() {
            addCriterion("User_commission is not null");
            return (Criteria) this;
        }

        public Criteria andUserCommissionEqualTo(BigDecimal value) {
            addCriterion("User_commission =", value, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionNotEqualTo(BigDecimal value) {
            addCriterion("User_commission <>", value, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionGreaterThan(BigDecimal value) {
            addCriterion("User_commission >", value, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("User_commission >=", value, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionLessThan(BigDecimal value) {
            addCriterion("User_commission <", value, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("User_commission <=", value, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionIn(List<BigDecimal> values) {
            addCriterion("User_commission in", values, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionNotIn(List<BigDecimal> values) {
            addCriterion("User_commission not in", values, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("User_commission between", value1, value2, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserCommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("User_commission not between", value1, value2, "userCommission");
            return (Criteria) this;
        }

        public Criteria andUserTypeIsNull() {
            addCriterion("User_type is null");
            return (Criteria) this;
        }

        public Criteria andUserTypeIsNotNull() {
            addCriterion("User_type is not null");
            return (Criteria) this;
        }

        public Criteria andUserTypeEqualTo(Boolean value) {
            addCriterion("User_type =", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotEqualTo(Boolean value) {
            addCriterion("User_type <>", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeGreaterThan(Boolean value) {
            addCriterion("User_type >", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeGreaterThanOrEqualTo(Boolean value) {
            addCriterion("User_type >=", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLessThan(Boolean value) {
            addCriterion("User_type <", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLessThanOrEqualTo(Boolean value) {
            addCriterion("User_type <=", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeIn(List<Boolean> values) {
            addCriterion("User_type in", values, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotIn(List<Boolean> values) {
            addCriterion("User_type not in", values, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeBetween(Boolean value1, Boolean value2) {
            addCriterion("User_type between", value1, value2, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotBetween(Boolean value1, Boolean value2) {
            addCriterion("User_type not between", value1, value2, "userType");
            return (Criteria) this;
        }

        public Criteria andPidIsNull() {
            addCriterion("PId is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("PId is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(String value) {
            addCriterion("PId =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(String value) {
            addCriterion("PId <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(String value) {
            addCriterion("PId >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(String value) {
            addCriterion("PId >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(String value) {
            addCriterion("PId <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(String value) {
            addCriterion("PId <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLike(String value) {
            addCriterion("PId like", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotLike(String value) {
            addCriterion("PId not like", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<String> values) {
            addCriterion("PId in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<String> values) {
            addCriterion("PId not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(String value1, String value2) {
            addCriterion("PId between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(String value1, String value2) {
            addCriterion("PId not between", value1, value2, "pid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}